OLAP Data Cube Wizard - Build the SQL statements

OLAP Data Cubes are populated by one or more datasets. If your data is arranged in a true "star" schema (with simple dimension tables), you can simply create your fact and dimension table queries and link them when you configure the dimensions. If your data is not arranged in a star schema, it is typically best to simply create a single query that contains all your measures and dimensions (making sure to join the tables appropriately). This technique can actually be easier than building the OLAP Data Cube using multiple datasets anyway, so you might consider doing it that way even if you do have a true star schema.

Note: If you create multiple datasets, you'll need to do an extra step for each dimension that you add. It is often simpler to create a single query that contains both your measures and dimensions so you can skip that step later on.

The Build OLAP Data Cube dialog containing SQL statements used to create the cube. The Data Sets pane contains the text Fact Table.

 


Need More Help?

If you need additional help creating OLAP Cubes, refer to the Getting Started with OLAP Cubes page.